/*
 Navicat Premium Data Transfer

 Source Server         : LocalHost
 Source Server Type    : SQL Server
 Source Server Version : 15002000
 Source Host           : LocalHost:1433
 Source Catalog        : wiUniGUI
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 15002000
 File Encoding         : 65001

 Date: 25/03/2021 21:25:31
*/


-- ----------------------------
-- Table structure for tblSystemParameters
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tblSystemParameters]') AND type IN ('U'))
	DROP TABLE [dbo].[tblSystemParameters]
GO

CREATE TABLE [dbo].[tblSystemParameters] (
  [fldCompanyCode] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldCompanyName] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldHaveSales] bit DEFAULT 1 NOT NULL,
  [fldHavePurchase] bit DEFAULT 1 NOT NULL,
  [fldHaveInventory] bit DEFAULT 1 NOT NULL,
  [fldHaveProduction] bit DEFAULT 1 NOT NULL,
  [fldHaveQuality] bit  NOT NULL,
  [fldDateFormat] varchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldFinancialYearEndMonth] int DEFAULT 0 NOT NULL,
  [fldSMTP] varchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldSendEmail] bit DEFAULT 0 NOT NULL,
  [fldSMTPUserName] varchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldSMTPPassword] varchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldAccount] bit DEFAULT 0 NOT NULL,
  [fldQty] numeric(18,2)  NULL,
  [fldVoucherNo] varchar(30) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldComputerDate] bit DEFAULT 1 NOT NULL,
  [fldUserDefineDate] datetime DEFAULT getdate() NOT NULL,
  [fldUserFunctionName] bit DEFAULT 0 NOT NULL,
  [fldReportPath] varchar(200) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldReportExtend] varchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldCompanyAddress1] nvarchar(60) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldCompanyAddress2] nvarchar(60) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldTelephoneNo] varchar(30) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldFaxNo] varchar(30) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldEmail] varchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldPostalCode] varchar(30) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldWebsite] varchar(30) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldLogoPath] varchar(200) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldBankName] nvarchar(200) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldBankAddress] nvarchar(200) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldACName] nvarchar(200) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldACNo] varchar(30) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldEnterChangeFocus] bit DEFAULT 0 NOT NULL,
  [fldCurrencyCode] varchar(30) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldDecimalPlaceQty] int DEFAULT 0 NOT NULL,
  [fldDecimalPlaceAmount] int DEFAULT 0 NOT NULL,
  [fldDecimalPlaceUnitCost] int DEFAULT 0 NOT NULL,
  [fldDecimalPlaceUnitPrice] int DEFAULT 0 NOT NULL,
  [fldUserLog] bit DEFAULT 0 NOT NULL,
  [fldEffectiveFromDate] datetime DEFAULT getdate() NOT NULL,
  [fldEffectiveToDate] datetime DEFAULT getdate() NOT NULL,
  [fldToolsButton] int DEFAULT 0 NOT NULL,
  [fldWallPaperFilename] varchar(200) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldVoucherNoDate] datetime DEFAULT getdate() NOT NULL,
  [fldHaveEffectiveToDate] bit DEFAULT 0 NOT NULL,
  [fldNewStyleYearCode] varchar(30) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldDeliveryQtyControl] bit DEFAULT 0 NOT NULL,
  [fldSalesSubscriptionRate] numeric(18,2) DEFAULT 0 NOT NULL,
  [fldDeliverySubscriptionRate] numeric(18,2) DEFAULT 0 NOT NULL,
  [fldDOHasSO] bit DEFAULT 0 NOT NULL,
  [fldSIHasDO] bit DEFAULT 0 NOT NULL,
  [fldGRHasPO] bit DEFAULT 0 NOT NULL,
  [fldPIHasGR] bit DEFAULT 0 NOT NULL,
  [fldGoodsReceivedQtyControl] bit DEFAULT 0 NOT NULL,
  [fldItemZeroPriceControlForP] bit DEFAULT 0 NOT NULL,
  [fldGoodsReceivedDateControl] bit DEFAULT 0 NOT NULL,
  [fldPerferredVendorControl] bit DEFAULT 0 NOT NULL,
  [fldCostingMethod] varchar(30) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldMaterailIssuedQtyControl] bit DEFAULT 0 NOT NULL,
  [fldGoodsReceivedCostControl] bit DEFAULT 0 NOT NULL,
  [fldItemAmountChangeControl] bit DEFAULT 0 NOT NULL,
  [fldItemZeroPriceControlForS] bit DEFAULT 0 NOT NULL,
  [fldMOCompleteProcessCostAllo] bit DEFAULT 0 NOT NULL,
  [fldDOAutoGenerateSI] bit DEFAULT 0 NOT NULL,
  [fldMOAutoGenerateMI] bit DEFAULT 0 NOT NULL,
  [fldMPSAutoGenerateMO] bit DEFAULT 0 NOT NULL,
  [fldGRAutoGeneratePI] bit DEFAULT 0 NOT NULL,
  [fldPRAutoGenerateMI] bit DEFAULT 0 NOT NULL,
  [fldPPAutoGenerateBC] bit DEFAULT 0 NOT NULL,
  [fldPRMaterialDistribute] int DEFAULT 0 NOT NULL,
  [fldBOMEffectiveMonth] int DEFAULT 1 NOT NULL,
  [fldRoutingEffectiveMonth] int DEFAULT 1 NOT NULL,
  [fldApprovalEffectiveMonth] int DEFAULT 1 NOT NULL,
  [fldEffectiveDate] varchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldCreator] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldCreateTime] datetime DEFAULT getdate() NOT NULL,
  [fldLastModifier] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldLastModTime] datetime DEFAULT getdate() NOT NULL,
  [fldNoOfMod] int DEFAULT 1 NOT NULL
)
GO

ALTER TABLE [dbo].[tblSystemParameters] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of tblSystemParameters
-- ----------------------------
INSERT INTO [dbo].[tblSystemParameters] ([fldCompanyCode], [fldCompanyName], [fldHaveSales], [fldHavePurchase], [fldHaveInventory], [fldHaveProduction], [fldHaveQuality], [fldDateFormat], [fldFinancialYearEndMonth], [fldSMTP], [fldSendEmail], [fldSMTPUserName], [fldSMTPPassword], [fldAccount], [fldQty], [fldVoucherNo], [fldComputerDate], [fldUserDefineDate], [fldUserFunctionName], [fldReportPath], [fldReportExtend], [fldCompanyAddress1], [fldCompanyAddress2], [fldTelephoneNo], [fldFaxNo], [fldEmail], [fldPostalCode], [fldWebsite], [fldLogoPath], [fldBankName], [fldBankAddress], [fldACName], [fldACNo], [fldEnterChangeFocus], [fldCurrencyCode], [fldDecimalPlaceQty], [fldDecimalPlaceAmount], [fldDecimalPlaceUnitCost], [fldDecimalPlaceUnitPrice], [fldUserLog], [fldEffectiveFromDate], [fldEffectiveToDate], [fldToolsButton], [fldWallPaperFilename], [fldVoucherNoDate], [fldHaveEffectiveToDate], [fldNewStyleYearCode], [fldDeliveryQtyControl], [fldSalesSubscriptionRate], [fldDeliverySubscriptionRate], [fldDOHasSO], [fldSIHasDO], [fldGRHasPO], [fldPIHasGR], [fldGoodsReceivedQtyControl], [fldItemZeroPriceControlForP], [fldGoodsReceivedDateControl], [fldPerferredVendorControl], [fldCostingMethod], [fldMaterailIssuedQtyControl], [fldGoodsReceivedCostControl], [fldItemAmountChangeControl], [fldItemZeroPriceControlForS], [fldMOCompleteProcessCostAllo], [fldDOAutoGenerateSI], [fldMOAutoGenerateMI], [fldMPSAutoGenerateMO], [fldGRAutoGeneratePI], [fldPRAutoGenerateMI], [fldPPAutoGenerateBC], [fldPRMaterialDistribute], [fldBOMEffectiveMonth], [fldRoutingEffectiveMonth], [fldApprovalEffectiveMonth], [fldEffectiveDate], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'wiUniGUI', N'wiUniGUI CO., LTD.', N'1', N'1', N'1', N'1', N'1', N'YYYY/MM/DD', N'12', N'192.168.2.1', N'0', N'', N'', N'0', N'200.00', N'V0000034', N'1', N'2003-05-08 00:00:00.000', N'1', N'\\swpc\fr3', N'.fr3', N'UNIT 406-8,4/F,TOWERI SILVERCORD, NO.30 CANTON ROAD, ', N'Tsim Sha Tsui, KOWLOON, HONGKONG', N'(852)2341 4361', N'(852)2341 9444', N'sales@OceanFur.com', N'523648', N'www.OceanFur.com', N'', N'DBS BANK (HONG KONG) LTD. WESTERN BRANCH, ', N'266 QUEEN''S ROAD WEST, HONG KONG', N'OCEAN FUR CO., LTD.', N'016 884 601033224', N'1', N'USD', N'3', N'2', N'2', N'2', N'1', N'2003-05-01 00:00:00.000', N'2010-05-01 00:00:00.000', N'2', N'', N'2003-05-01 00:00:00.000', N'0', N'06', N'0', N'.00', N'.00', N'1', N'1', N'0', N'1', N'1', N'1', N'0', N'0', N'cmAverageCost', N'0', N'1', N'1', N'1', N'0', N'0', N'0', N'0', N'0', N'0', N'1', N'0', N'1', N'1', N'1', N'0Fcuo3iiPjV+0WxQdRXQzBFBScDAEbQ5', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SUPERVISOR', N'2015-10-16 16:28:39.000', N'110')
GO


-- ----------------------------
-- Table structure for tblSystemParametersAccountDetails
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tblSystemParametersAccountDetails]') AND type IN ('U'))
	DROP TABLE [dbo].[tblSystemParametersAccountDetails]
GO

CREATE TABLE [dbo].[tblSystemParametersAccountDetails] (
  [fldCompanyCode] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldBankName] nvarchar(200) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldBankDistrictCode] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldSwift] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldACName] nvarchar(200) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldACNo] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldDefault] bit DEFAULT 0 NOT NULL
)
GO

ALTER TABLE [dbo].[tblSystemParametersAccountDetails] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of tblSystemParametersAccountDetails
-- ----------------------------

-- ----------------------------
-- Table structure for tblSystemParametersAddressDetails
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tblSystemParametersAddressDetails]') AND type IN ('U'))
	DROP TABLE [dbo].[tblSystemParametersAddressDetails]
GO

CREATE TABLE [dbo].[tblSystemParametersAddressDetails] (
  [fldCompanyCode] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldDeliveryAddressCode] varchar(30) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldConveyancerCode] varchar(30) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldPortCode] varchar(30) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldDeliveryAddress1] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldDeliveryAddress2] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldDeliveryAddress3] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldDeliveryAddress4] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldDHL] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldFederalExpress] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldOthers] nvarchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldDefault] bit DEFAULT 0 NOT NULL
)
GO

ALTER TABLE [dbo].[tblSystemParametersAddressDetails] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'tblVendor fldCategory = ''ctConveyance''',
'SCHEMA', N'dbo',
'TABLE', N'tblSystemParametersAddressDetails',
'COLUMN', N'fldConveyancerCode'
GO


-- ----------------------------
-- Records of tblSystemParametersAddressDetails
-- ----------------------------

-- ----------------------------
-- Table structure for tblSystemParametersAssociateChargeDetails
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tblSystemParametersAssociateChargeDetails]') AND type IN ('U'))
	DROP TABLE [dbo].[tblSystemParametersAssociateChargeDetails]
GO

CREATE TABLE [dbo].[tblSystemParametersAssociateChargeDetails] (
  [fldCompanyCode] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldSeqNo] int  IDENTITY(1,1) NOT NULL,
  [fldAssociateChargeCode] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldAssociateChargeDescription] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldAssociateRate] numeric(18,4)  NOT NULL,
  [fldDefault] bit DEFAULT 0 NOT NULL,
  [fldRemarks] nvarchar(1000) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL
)
GO

ALTER TABLE [dbo].[tblSystemParametersAssociateChargeDetails] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of tblSystemParametersAssociateChargeDetails
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tblSystemParametersAssociateChargeDetails] ON
GO

SET IDENTITY_INSERT [dbo].[tblSystemParametersAssociateChargeDetails] OFF
GO


-- ----------------------------
-- Table structure for tblSystemParametersAutoGenNoDetails
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tblSystemParametersAutoGenNoDetails]') AND type IN ('U'))
	DROP TABLE [dbo].[tblSystemParametersAutoGenNoDetails]
GO

CREATE TABLE [dbo].[tblSystemParametersAutoGenNoDetails] (
  [fldCompanyCode] varchar(30) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldFunctionCode] varchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldKeyFieldNo] varchar(30) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldAutoGenNoDate] datetime DEFAULT getdate() NOT NULL,
  [fldSeqNo] int DEFAULT 0 NOT NULL,
  [fldDefault] bit DEFAULT 0 NOT NULL
)
GO

ALTER TABLE [dbo].[tblSystemParametersAutoGenNoDetails] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of tblSystemParametersAutoGenNoDetails
-- ----------------------------
INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'', N'flManufacturingOrder', N'MO31-YY00057', N'2014-07-03 00:00:00.000', N'14', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'', N'flModifyRequisition', N'WA-YYMM0004', N'2009-07-04 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'', N'flReturnFactory', N'RF-YYMM003', N'2009-05-07 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'', N'flSalesOrder', N'', N'2007-02-25 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'', N'flSalesOrder', N'UUU-YY-C001', N'2007-02-25 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'', N'flStyleClassEntry', N'SC-YYMM016', N'2011-04-03 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'', N'flTest', N'RF-YYMM001', N'2009-05-05 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flApartProduct', N'AP-YYMM002', N'2008-06-25 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flApartProductReceived', N'AR-YYMM002', N'2008-06-28 00:00:00.000', N'1', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flBreakCoat', N'BC-YYMM0001', N'2010-10-05 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flCallingUpOfProduction', N'CU-YYMM0003', N'2010-07-27 00:00:00.000', N'1', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flCheckStock', N'CS-07100248', N'2007-10-01 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flCustomerBalance', N'CB-YYMM001', N'2007-08-27 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flCutOut', N'CO-YYMM0015', N'2014-07-09 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flDeliveryOrder', N'DO-YYMM0019', N'2014-07-28 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flDocumentApproval', N'DA01-YYMM00001', N'2003-09-18 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flGoodsAdjustment', N'GA-YYMM0005', N'2014-07-09 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flGoodsReceived', N'GR-YYMM0004', N'2014-07-04 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flGoodsTransfer', N'CP-YYMM0010', N'2014-07-25 00:00:00.000', N'1', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flGoodsTransfer', N'GT-YYMM0001', N'2014-07-08 00:00:00.000', N'2', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flItemRequisition', N'IO-YYMM0001', N'2010-08-31 00:00:00.000', N'2', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flItemRequisition', N'IR-YYMM0031', N'2014-07-10 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flItemReturn', N'IT-YYMM0019', N'2014-07-10 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flManufacturingOrder', N'MO01-YY00025', N'2013-06-17 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flManufacturingOrder', N'MO02-YY00238', N'2012-04-25 00:00:00.000', N'2', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flManufacturingOrder', N'MO03-YY00006', N'2014-03-26 00:00:00.000', N'3', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flManufacturingOrder', N'MO04-YY00004', N'2012-09-11 00:00:00.000', N'4', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flManufacturingOrder', N'MO05-YY00024', N'2013-08-03 00:00:00.000', N'5', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flManufacturingOrder', N'MO06-YY00003', N'2012-09-19 00:00:00.000', N'6', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flManufacturingOrder', N'MO07-YY00425', N'2014-07-09 00:00:00.000', N'7', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flManufacturingOrder', N'MO08-YY01250', N'2014-07-10 00:00:00.000', N'8', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flManufacturingOrder', N'MO09-YY00003', N'2013-03-25 00:00:00.000', N'9', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flManufacturingOrder', N'MO10-YY00001', N'2012-10-30 00:00:00.000', N'10', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flManufacturingOrder', N'MO11-YY00003', N'2012-01-04 00:00:00.000', N'11', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flManufacturingOrder', N'MO12-YY00006', N'2012-01-09 00:00:00.000', N'12', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flManufacturingOrder', N'MO30-YY00001', N'2011-05-17 00:00:00.000', N'13', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flManufacturingProcess', N'MP01-YY000074', N'2014-06-21 10:54:32.063', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flManufacturingRender', N'ME01-YY001526', N'2014-07-10 14:35:19.377', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flMaterialIssued', N'MI01-YYMM0000', N'2004-01-17 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flMaterialIssued', N'MI02-YYMM0000', N'2003-11-10 00:00:00.000', N'2', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flMaterialReturn', N'MR01-YYMM0000', N'2003-11-18 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flMaterialReturn', N'MR02-YYMM0000', N'2003-11-10 00:00:00.000', N'2', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flNeedleWork', N'NW-YYMM0019', N'2014-07-07 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flOutwardProcessing', N'OP-YYMM0005', N'2014-07-10 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flOutwardReceived', N'OR-YYMM0005', N'2014-07-09 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flOutwardReturn', N'OT-YYMM0001', N'2014-07-05 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flPackingList', N'PL-YYMM0003', N'2011-03-18 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flProductReceived', N'PR01-YYMM0000', N'2003-11-10 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flProductReceived', N'PR02-YYMM0000', N'2003-11-10 00:00:00.000', N'2', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flProductToStock', N'PS-YYMM0012', N'2014-07-09 00:00:00.000', N'2', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flProductToStock', N'PT-YYMM0001', N'2012-03-15 18:11:48.607', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flPurchaseReturn', N'PR-YYMM0002', N'2006-11-15 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flQuotation', N'QT01-YYMM0000', N'2006-10-27 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flQuotation', N'QT02-YYMM0000', N'2006-10-27 00:00:00.000', N'2', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flRequestTinct', N'RT-YYMM0003', N'2007-06-13 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flRequestTinctOrder', N'RT-YYMM0060', N'2014-07-10 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flRoutingPrice', N'RP-YYMM002', N'2009-08-17 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flSalesChange', N'SC-YYMM0003', N'2014-07-09 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flSalesInvoice', N'SI-YYMM0000', N'2006-10-27 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flSalesPriceAdjust', N'SP-YYMM0000', N'2007-06-30 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flSalesQuotation', N'SQ-YYMM0001', N'2008-12-04 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flSalesRefund', N'SD-YYMM0001', N'2008-09-20 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flSalesReserved', N'SV-YYMM0015', N'2008-08-18 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flSalesReturn', N'SR-YYMM0005', N'2014-06-20 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flSalesSubscription', N'SS-YYMM0015', N'2010-04-26 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flSewingMachine', N'SM-YYMM0003', N'2014-06-26 00:00:00.000', N'1', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flShippingAdvice', N'SA-YYMM0000', N'2006-10-27 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flSilkDeduck', N'SD-YYMM0009', N'2008-11-06 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flStyle', N'AB', N'2012-03-09 00:00:00.000', N'1', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flStyle', N'AB', N'2012-03-09 00:00:00.000', N'2', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flStyle', N'AB', N'2012-03-09 00:00:00.000', N'3', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flStyle', N'AB', N'2012-03-09 00:00:00.000', N'5', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flStyleNoChange', N'SNC-YYMM0001', N'2014-07-02 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flUselessItem', N'UI-YYMM0001', N'2014-07-03 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flWorkOverAgainRequisition', N'WA-YYMM0001', N'2014-07-10 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'flZewingMachine', N'ZM-YYMM0002', N'2014-06-25 00:00:00.000', N'1', N'0')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'fmAmendgenerativeodd', N'WA-YYMM0001', N'2010-05-11 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCEANFUR', N'fmRepairComplete', N'RC-YYMM0001', N'2010-05-20 00:00:00.000', N'1', N'1')
GO

INSERT INTO [dbo].[tblSystemParametersAutoGenNoDetails] ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldAutoGenNoDate], [fldSeqNo], [fldDefault]) VALUES (N'OCENAFUR', N'flStyle', N'AB', N'2012-03-09 00:00:00.000', N'4', N'0')
GO


-- ----------------------------
-- Table structure for tblSystemParametersExchangeRateDetails
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tblSystemParametersExchangeRateDetails]') AND type IN ('U'))
	DROP TABLE [dbo].[tblSystemParametersExchangeRateDetails]
GO

CREATE TABLE [dbo].[tblSystemParametersExchangeRateDetails] (
  [fldCompanyCode] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldSeqNo] int  IDENTITY(1,1) NOT NULL,
  [fldExchangeRateCode] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldExchangeRateDescription] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldExchangeRate] numeric(18,4) DEFAULT 1 NOT NULL,
  [fldRemarks] varchar(1000) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL
)
GO

ALTER TABLE [dbo].[tblSystemParametersExchangeRateDetails] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of tblSystemParametersExchangeRateDetails
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tblSystemParametersExchangeRateDetails] ON
GO

SET IDENTITY_INSERT [dbo].[tblSystemParametersExchangeRateDetails] OFF
GO


-- ----------------------------
-- Table structure for tblSystemParametersLoadingExpressionDetails
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tblSystemParametersLoadingExpressionDetails]') AND type IN ('U'))
	DROP TABLE [dbo].[tblSystemParametersLoadingExpressionDetails]
GO

CREATE TABLE [dbo].[tblSystemParametersLoadingExpressionDetails] (
  [fldCompanyCode] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldSeqNo] int  IDENTITY(1,1) NOT NULL,
  [fldExpressionCode] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldExpressionDescription] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldExpression] numeric(18,4)  NOT NULL,
  [fldDefault] bit DEFAULT 0 NOT NULL,
  [fldRemarks] varchar(1000) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL
)
GO

ALTER TABLE [dbo].[tblSystemParametersLoadingExpressionDetails] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of tblSystemParametersLoadingExpressionDetails
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tblSystemParametersLoadingExpressionDetails] ON
GO

SET IDENTITY_INSERT [dbo].[tblSystemParametersLoadingExpressionDetails] OFF
GO


-- ----------------------------
-- Table structure for tblSystemParametersOtherMachiningChargeDetails
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tblSystemParametersOtherMachiningChargeDetails]') AND type IN ('U'))
	DROP TABLE [dbo].[tblSystemParametersOtherMachiningChargeDetails]
GO

CREATE TABLE [dbo].[tblSystemParametersOtherMachiningChargeDetails] (
  [fldCompanyCode] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldSeqNo] int  NOT NULL,
  [fldOtherMachiningChargeCode] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldOtherMachiningChargeDescription] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldAmount] numeric(18,4)  NOT NULL,
  [fldCurrencyCode] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldDefault] bit DEFAULT 0 NOT NULL
)
GO

ALTER TABLE [dbo].[tblSystemParametersOtherMachiningChargeDetails] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of tblSystemParametersOtherMachiningChargeDetails
-- ----------------------------

-- ----------------------------
-- Table structure for tblSystemParametersProfitRateDetails
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tblSystemParametersProfitRateDetails]') AND type IN ('U'))
	DROP TABLE [dbo].[tblSystemParametersProfitRateDetails]
GO

CREATE TABLE [dbo].[tblSystemParametersProfitRateDetails] (
  [fldCompanyCode] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldSeqNo] int  IDENTITY(1,1) NOT NULL,
  [fldProfitLevelCode] varchar(10) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldProfitLevelDescription] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldProfitRate] numeric(18,4)  NOT NULL,
  [fldRemarks] varchar(1000) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL
)
GO

ALTER TABLE [dbo].[tblSystemParametersProfitRateDetails] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of tblSystemParametersProfitRateDetails
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tblSystemParametersProfitRateDetails] ON
GO

SET IDENTITY_INSERT [dbo].[tblSystemParametersProfitRateDetails] OFF
GO


-- ----------------------------
-- Primary Key structure for table tblSystemParameters
-- ----------------------------
ALTER TABLE [dbo].[tblSystemParameters] ADD CONSTRAINT [PK_tblSystemParameters] PRIMARY KEY CLUSTERED ([fldCompanyCode])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tblSystemParametersAccountDetails
-- ----------------------------
ALTER TABLE [dbo].[tblSystemParametersAccountDetails] ADD CONSTRAINT [PK_tblSystemParametersAccountDetails] PRIMARY KEY CLUSTERED ([fldCompanyCode], [fldBankName], [fldACNo])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tblSystemParametersAddressDetails
-- ----------------------------
ALTER TABLE [dbo].[tblSystemParametersAddressDetails] ADD CONSTRAINT [PK_tblSystemParametersAddressDetails] PRIMARY KEY CLUSTERED ([fldCompanyCode], [fldDeliveryAddressCode])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for tblSystemParametersAssociateChargeDetails
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[tblSystemParametersAssociateChargeDetails]', RESEED, 2)
GO


-- ----------------------------
-- Primary Key structure for table tblSystemParametersAssociateChargeDetails
-- ----------------------------
ALTER TABLE [dbo].[tblSystemParametersAssociateChargeDetails] ADD CONSTRAINT [PK_tblSystemParametersAssociateChargeDetails] PRIMARY KEY CLUSTERED ([fldCompanyCode], [fldSeqNo])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tblSystemParametersAutoGenNoDetails
-- ----------------------------
ALTER TABLE [dbo].[tblSystemParametersAutoGenNoDetails] ADD CONSTRAINT [PK_tblSystemParametersAutoGenNoDetails] PRIMARY KEY CLUSTERED ([fldCompanyCode], [fldFunctionCode], [fldKeyFieldNo], [fldSeqNo])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for tblSystemParametersExchangeRateDetails
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[tblSystemParametersExchangeRateDetails]', RESEED, 3)
GO


-- ----------------------------
-- Primary Key structure for table tblSystemParametersExchangeRateDetails
-- ----------------------------
ALTER TABLE [dbo].[tblSystemParametersExchangeRateDetails] ADD CONSTRAINT [PK_tblSystemParametersExchangeRateDetails] PRIMARY KEY CLUSTERED ([fldCompanyCode], [fldSeqNo])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for tblSystemParametersLoadingExpressionDetails
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[tblSystemParametersLoadingExpressionDetails]', RESEED, 1)
GO


-- ----------------------------
-- Primary Key structure for table tblSystemParametersLoadingExpressionDetails
-- ----------------------------
ALTER TABLE [dbo].[tblSystemParametersLoadingExpressionDetails] ADD CONSTRAINT [PK_tblSystemParametersLoadingDetails] PRIMARY KEY CLUSTERED ([fldCompanyCode], [fldSeqNo])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table tblSystemParametersOtherMachiningChargeDetails
-- ----------------------------
CREATE UNIQUE NONCLUSTERED INDEX [IX_tblSystemParametersOtherMachiningChargeDetails]
ON [dbo].[tblSystemParametersOtherMachiningChargeDetails] (
  [fldSeqNo] ASC
)
WITH (
  FILLFACTOR = 90
)
GO


-- ----------------------------
-- Primary Key structure for table tblSystemParametersOtherMachiningChargeDetails
-- ----------------------------
ALTER TABLE [dbo].[tblSystemParametersOtherMachiningChargeDetails] ADD CONSTRAINT [PK_tblSystemParametersOtherMachiningChargeDetails] PRIMARY KEY CLUSTERED ([fldCompanyCode], [fldOtherMachiningChargeCode])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for tblSystemParametersProfitRateDetails
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[tblSystemParametersProfitRateDetails]', RESEED, 3)
GO


-- ----------------------------
-- Primary Key structure for table tblSystemParametersProfitRateDetails
-- ----------------------------
ALTER TABLE [dbo].[tblSystemParametersProfitRateDetails] ADD CONSTRAINT [PK_tblSystemParameterSalesProfitRateDetails] PRIMARY KEY CLUSTERED ([fldCompanyCode], [fldSeqNo])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

